set hive.exec.dynamic.partition=true;--动态分区
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions=20;--每天生成 20 个分区
set hive.exec.max.dynamic.partitions.pernode=20;--每天生成 20 个分区
insert overwrite table jms_dim.dim_yl_nwm_cost_config_detail
select
id
,cost_id
,first_code
,first_name
,second_code
,second_name
,cost_unit
,freight
,remark
,char_field1
,char_field2
,char_field3
,char_field4
,char_field5
from jms_ods.yl_nwm_cost_config_detail
where dt= '{{ execution_date | cst_ds }}'
distribute by 1 ;